package com.zcz.umengpush.mapper;

import com.zcz.umengpush.pojo.PushMsg;
import com.zcz.umengpush.pojo.PushMsgHistory;
import org.apache.ibatis.annotations.Insert;
import tk.mybatis.mapper.common.Mapper;

/**
 * @author 王卫帅
 */
public interface PushMsgHistoryMapper extends Mapper<PushMsgHistory> {
    /**
     * 每天2点  把push_msg表里的数据  移动到 Push_msg_history表里
     * @return
     */
    @Insert("insert into push_msg_history select *  from  push_msg  where  to_char(adddate,'YYYY-MM-DD') &lt;= to_char(SYSDATE-1,'YYYY-MM-DD')")
    int move();



}
